package com.zhiyou.brank.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.zhiyou.model.FYGrad;
import com.zhiyou.model.FyScore;

public interface FlyGrad {
	
	/**
	 * 根据学生id和班级id查询学生学习成绩
	 * @param class_id
	 * @param exam_id
	 * @return
	 */
	public List<FyScore> selectGradOne(@Param("class_id")Integer class_id,@Param("exam_id")Integer exam_id);
	
	/**
	 * 平均分
	 * @param class_id
	 * @param exam_id
	 * @param course_id
	 * @return
	 */
	public FYGrad selectGradTwo(@Param("class_id")Integer class_id,@Param("exam_id")Integer exam_id,@Param("course_id")Integer course_id);
}
